﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Common;

namespace Ex04
{

    /// <summary>
    /// Simple Linq to SQL query
    /// </summary>
    class Program
    {
        static void Main(string[] args)
        {
            var db = new NorthwindEntities();
            (from c in db.Customers
            where c.Name.Contains("a")
            orderby c.Name.Length
            select c.Name.ToUpper())
            .Dump();
            Console.ReadKey();
        }
    }
}
